Dataset statistics
| Number of variables | 18 |
|---|---|
| Number of observations | 8950 |
| Missing cells | 314 |
| Missing cells (%) | 0.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 1.2 MiB |
| Average record size in memory | 144.0 B |
Variable types
| NUM | 17 |
|---|---|
| CAT | 1 |
Reproduction
| Analysis started | 2020-06-16 04:16:56.425065 |
|---|---|
| Analysis finished | 2020-06-16 04:18:11.323800 |
| Duration | 1 minute and 14.9 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
ONEOFF_PURCHASES is highly correlated with PURCHASES | High correlation |
PURCHASES is highly correlated with ONEOFF_PURCHASES | High correlation |
MINIMUM_PAYMENTS has 313 (3.5%) missing values | Missing |
CUST_ID has unique values | Unique |
PURCHASES has 2044 (22.8%) zeros | Zeros |
ONEOFF_PURCHASES has 4302 (48.1%) zeros | Zeros |
INSTALLMENTS_PURCHASES has 3916 (43.8%) zeros | Zeros |
CASH_ADVANCE has 4628 (51.7%) zeros | Zeros |
PURCHASES_FREQUENCY has 2043 (22.8%) zeros | Zeros |
ONEOFF_PURCHASES_FREQUENCY has 4302 (48.1%) zeros | Zeros |
PURCHASES_INSTALLMENTS_FREQUENCY has 3915 (43.7%) zeros | Zeros |
CASH_ADVANCE_FREQUENCY has 4628 (51.7%) zeros | Zeros |
CASH_ADVANCE_TRX has 4628 (51.7%) zeros | Zeros |
PURCHASES_TRX has 2044 (22.8%) zeros | Zeros |
PAYMENTS has 240 (2.7%) zeros | Zeros |
PRC_FULL_PAYMENT has 5903 (66.0%) zeros | Zeros |
| Distinct count | 8950 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 69.9 KiB |
| C15411 | 1 |
|---|---|
| C15360 | 1 |
| C14786 | 1 |
| C18220 | 1 |
| C11450 | 1 |
| Other values (8945) |
| Value | Count | Frequency (%) | |
| C15411 | 1 | < 0.1% | |
| C15360 | 1 | < 0.1% | |
| C14786 | 1 | < 0.1% | |
| C18220 | 1 | < 0.1% | |
| C11450 | 1 | < 0.1% | |
| C10753 | 1 | < 0.1% | |
| C15295 | 1 | < 0.1% | |
| C15309 | 1 | < 0.1% | |
| C11264 | 1 | < 0.1% | |
| C13292 | 1 | < 0.1% | |
| Other values (8940) | 8940 | 99.9% |
Length
| Max length | 6 |
|---|---|
| Median length | 6 |
| Mean length | 6 |
| Min length | 6 |
BALANCE
Real number (ℝ≥0)
| Distinct count | 8871 |
|---|---|
| Unique (%) | 99.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1564.4748276781006 |
|---|---|
| Minimum | 0.0 |
| Maximum | 19043.13856 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 8.81451835 |
| Q1 | 128.2819155 |
| median | 873.385231 |
| Q3 | 2054.140036 |
| 95-th percentile | 5909.111808 |
| Maximum | 19043.13856 |
| Range | 19043.13856 |
| Interquartile range (IQR) | 1925.85812 |
Descriptive statistics
| Standard deviation | 2081.531879 |
|---|---|
| Coefficient of variation (CV) | 1.330498799 |
| Kurtosis | 7.6747513 |
| Mean | 1564.474828 |
| Median Absolute Deviation (MAD) | 799.865197 |
| Skewness | 2.393386043 |
| Sum | 14002049.71 |
| Variance | 4332774.965 |
| Value | Count | Frequency (%) | |
| 0 | 80 | 0.9% | |
| 1100.941072 | 1 | < 0.1% | |
| 40.074484 | 1 | < 0.1% | |
| 2093.844656 | 1 | < 0.1% | |
| 179.765708 | 1 | < 0.1% | |
| 12.654903 | 1 | < 0.1% | |
| 1893.704851 | 1 | < 0.1% | |
| 1571.218695 | 1 | < 0.1% | |
| 31.285608 | 1 | < 0.1% | |
| 1772.323491 | 1 | < 0.1% | |
| Other values (8861) | 8861 | 99.0% |
| Value | Count | Frequency (%) | |
| 0 | 80 | 0.9% | |
| 0.000199 | 1 | < 0.1% | |
| 0.001146 | 1 | < 0.1% | |
| 0.001214 | 1 | < 0.1% | |
| 0.001289 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 19043.13856 | 1 | < 0.1% | |
| 18495.55855 | 1 | < 0.1% | |
| 16304.88925 | 1 | < 0.1% | |
| 16259.44857 | 1 | < 0.1% | |
| 16115.5964 | 1 | < 0.1% |
BALANCE_FREQUENCY
Real number (ℝ≥0)
| Distinct count | 43 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.8772707255865921 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.0 |
| Zeros | 80 |
| Zeros (%) | 0.9% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.272727 |
| Q1 | 0.888889 |
| median | 1 |
| Q3 | 1 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.111111 |
Descriptive statistics
| Standard deviation | 0.2369040027 |
|---|---|
| Coefficient of variation (CV) | 0.2700466296 |
| Kurtosis | 3.092369622 |
| Mean | 0.8772707256 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.023265519 |
| Sum | 7851.572994 |
| Variance | 0.05612350649 |
| Value | Count | Frequency (%) | |
| 1 | 6211 | 69.4% | |
| 0.909091 | 410 | 4.6% | |
| 0.818182 | 278 | 3.1% | |
| 0.727273 | 223 | 2.5% | |
| 0.545455 | 219 | 2.4% | |
| 0.636364 | 209 | 2.3% | |
| 0.454545 | 172 | 1.9% | |
| 0.363636 | 170 | 1.9% | |
| 0.272727 | 151 | 1.7% | |
| 0.181818 | 146 | 1.6% | |
| Other values (33) | 761 | 8.5% |
| Value | Count | Frequency (%) | |
| 0 | 80 | 0.9% | |
| 0.090909 | 67 | 0.7% | |
| 0.1 | 8 | 0.1% | |
| 0.111111 | 5 | 0.1% | |
| 0.125 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 6211 | 69.4% | |
| 0.909091 | 410 | 4.6% | |
| 0.9 | 55 | 0.6% | |
| 0.888889 | 53 | 0.6% | |
| 0.875 | 57 | 0.6% |
| Distinct count | 6203 |
|---|---|
| Unique (%) | 69.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1003.2048335195531 |
|---|---|
| Minimum | 0.0 |
| Maximum | 49039.57 |
| Zeros | 2044 |
| Zeros (%) | 22.8% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 39.635 |
| median | 361.28 |
| Q3 | 1110.13 |
| 95-th percentile | 3998.6195 |
| Maximum | 49039.57 |
| Range | 49039.57 |
| Interquartile range (IQR) | 1070.495 |
Descriptive statistics
| Standard deviation | 2136.634782 |
|---|---|
| Coefficient of variation (CV) | 2.129809098 |
| Kurtosis | 111.3887709 |
| Mean | 1003.204834 |
| Median Absolute Deviation (MAD) | 361.28 |
| Skewness | 8.144269065 |
| Sum | 8978683.26 |
| Variance | 4565208.191 |
| Value | Count | Frequency (%) | |
| 0 | 2044 | 22.8% | |
| 45.65 | 27 | 0.3% | |
| 150 | 16 | 0.2% | |
| 60 | 16 | 0.2% | |
| 100 | 13 | 0.1% | |
| 300 | 13 | 0.1% | |
| 200 | 13 | 0.1% | |
| 450 | 12 | 0.1% | |
| 600 | 10 | 0.1% | |
| 70 | 10 | 0.1% | |
| Other values (6193) | 6776 | 75.7% |
| Value | Count | Frequency (%) | |
| 0 | 2044 | 22.8% | |
| 0.01 | 4 | < 0.1% | |
| 0.05 | 1 | < 0.1% | |
| 0.24 | 1 | < 0.1% | |
| 0.7 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 49039.57 | 1 | < 0.1% | |
| 41050.4 | 1 | < 0.1% | |
| 40040.71 | 1 | < 0.1% | |
| 38902.71 | 1 | < 0.1% | |
| 35131.16 | 1 | < 0.1% |
| Distinct count | 4014 |
|---|---|
| Unique (%) | 44.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 592.4373709497207 |
|---|---|
| Minimum | 0.0 |
| Maximum | 40761.25 |
| Zeros | 4302 |
| Zeros (%) | 48.1% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 38 |
| Q3 | 577.405 |
| 95-th percentile | 2671.094 |
| Maximum | 40761.25 |
| Range | 40761.25 |
| Interquartile range (IQR) | 577.405 |
Descriptive statistics
| Standard deviation | 1659.887917 |
|---|---|
| Coefficient of variation (CV) | 2.801794753 |
| Kurtosis | 164.187572 |
| Mean | 592.4373709 |
| Median Absolute Deviation (MAD) | 38 |
| Skewness | 10.04508288 |
| Sum | 5302314.47 |
| Variance | 2755227.898 |
| Value | Count | Frequency (%) | |
| 0 | 4302 | 48.1% | |
| 45.65 | 46 | 0.5% | |
| 50 | 17 | 0.2% | |
| 200 | 15 | 0.2% | |
| 60 | 13 | 0.1% | |
| 100 | 13 | 0.1% | |
| 70 | 12 | 0.1% | |
| 150 | 12 | 0.1% | |
| 1000 | 12 | 0.1% | |
| 250 | 11 | 0.1% | |
| Other values (4004) | 4497 | 50.2% |
| Value | Count | Frequency (%) | |
| 0 | 4302 | 48.1% | |
| 0.01 | 7 | 0.1% | |
| 0.02 | 2 | < 0.1% | |
| 0.05 | 1 | < 0.1% | |
| 0.24 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 40761.25 | 1 | < 0.1% | |
| 40624.06 | 1 | < 0.1% | |
| 34087.73 | 1 | < 0.1% | |
| 33803.84 | 1 | < 0.1% | |
| 26547.43 | 1 | < 0.1% |
| Distinct count | 4452 |
|---|---|
| Unique (%) | 49.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 411.0676446927374 |
|---|---|
| Minimum | 0.0 |
| Maximum | 22500.0 |
| Zeros | 3916 |
| Zeros (%) | 43.8% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 89 |
| Q3 | 468.6375 |
| 95-th percentile | 1750.0875 |
| Maximum | 22500 |
| Range | 22500 |
| Interquartile range (IQR) | 468.6375 |
Descriptive statistics
| Standard deviation | 904.3381152 |
|---|---|
| Coefficient of variation (CV) | 2.199973963 |
| Kurtosis | 96.57517753 |
| Mean | 411.0676447 |
| Median Absolute Deviation (MAD) | 89 |
| Skewness | 7.299119909 |
| Sum | 3679055.42 |
| Variance | 817827.4266 |
| Value | Count | Frequency (%) | |
| 0 | 3916 | 43.8% | |
| 100 | 14 | 0.2% | |
| 300 | 14 | 0.2% | |
| 200 | 14 | 0.2% | |
| 150 | 12 | 0.1% | |
| 125 | 11 | 0.1% | |
| 75 | 9 | 0.1% | |
| 225 | 8 | 0.1% | |
| 350 | 8 | 0.1% | |
| 450 | 8 | 0.1% | |
| Other values (4442) | 4936 | 55.2% |
| Value | Count | Frequency (%) | |
| 0 | 3916 | 43.8% | |
| 1.95 | 1 | < 0.1% | |
| 4.44 | 1 | < 0.1% | |
| 4.8 | 1 | < 0.1% | |
| 6.33 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 22500 | 1 | < 0.1% | |
| 15497.19 | 1 | < 0.1% | |
| 14686.1 | 1 | < 0.1% | |
| 13184.43 | 1 | < 0.1% | |
| 12738.47 | 1 | < 0.1% |
| Distinct count | 4323 |
|---|---|
| Unique (%) | 48.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 978.8711124654749 |
|---|---|
| Minimum | 0.0 |
| Maximum | 47137.211760000006 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1113.821139 |
| 95-th percentile | 4647.169122 |
| Maximum | 47137.21176 |
| Range | 47137.21176 |
| Interquartile range (IQR) | 1113.821139 |
Descriptive statistics
| Standard deviation | 2097.163877 |
|---|---|
| Coefficient of variation (CV) | 2.142431062 |
| Kurtosis | 52.89943411 |
| Mean | 978.8711125 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.166609074 |
| Sum | 8760896.457 |
| Variance | 4398096.325 |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 1286.356207 | 1 | < 0.1% | |
| 3816.470266 | 1 | < 0.1% | |
| 2495.298926 | 1 | < 0.1% | |
| 748.241727 | 1 | < 0.1% | |
| 1572.492719 | 1 | < 0.1% | |
| 5425.912807 | 1 | < 0.1% | |
| 9553.955906 | 1 | < 0.1% | |
| 341.360876 | 1 | < 0.1% | |
| 1424.442602 | 1 | < 0.1% | |
| Other values (4313) | 4313 | 48.2% |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 14.222216 | 1 | < 0.1% | |
| 18.042768 | 1 | < 0.1% | |
| 18.117967 | 1 | < 0.1% | |
| 18.123413 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 47137.21176 | 1 | < 0.1% | |
| 29282.10915 | 1 | < 0.1% | |
| 27296.48576 | 1 | < 0.1% | |
| 26268.69989 | 1 | < 0.1% | |
| 26194.04954 | 1 | < 0.1% |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.49035054837988823 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.0 |
| Zeros | 2043 |
| Zeros (%) | 22.8% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.083333 |
| median | 0.5 |
| Q3 | 0.916667 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.833334 |
Descriptive statistics
| Standard deviation | 0.4013707474 |
|---|---|
| Coefficient of variation (CV) | 0.8185383879 |
| Kurtosis | -1.638630948 |
| Mean | 0.4903505484 |
| Median Absolute Deviation (MAD) | 0.416667 |
| Skewness | 0.06016423586 |
| Sum | 4388.637408 |
| Variance | 0.1610984768 |
| Value | Count | Frequency (%) | |
| 1 | 2178 | 24.3% | |
| 0 | 2043 | 22.8% | |
| 0.083333 | 677 | 7.6% | |
| 0.916667 | 396 | 4.4% | |
| 0.5 | 395 | 4.4% | |
| 0.166667 | 392 | 4.4% | |
| 0.833333 | 373 | 4.2% | |
| 0.333333 | 367 | 4.1% | |
| 0.25 | 345 | 3.9% | |
| 0.583333 | 316 | 3.5% | |
| Other values (37) | 1468 | 16.4% |
| Value | Count | Frequency (%) | |
| 0 | 2043 | 22.8% | |
| 0.083333 | 677 | 7.6% | |
| 0.090909 | 43 | 0.5% | |
| 0.1 | 27 | 0.3% | |
| 0.111111 | 18 | 0.2% |
| Value | Count | Frequency (%) | |
| 1 | 2178 | 24.3% | |
| 0.916667 | 396 | 4.4% | |
| 0.909091 | 28 | 0.3% | |
| 0.9 | 24 | 0.3% | |
| 0.888889 | 18 | 0.2% |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.202457683575419 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.0 |
| Zeros | 4302 |
| Zeros (%) | 48.1% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.083333 |
| Q3 | 0.3 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.3 |
Descriptive statistics
| Standard deviation | 0.2983360652 |
|---|---|
| Coefficient of variation (CV) | 1.473572452 |
| Kurtosis | 1.161845601 |
| Mean | 0.2024576836 |
| Median Absolute Deviation (MAD) | 0.083333 |
| Skewness | 1.535612784 |
| Sum | 1811.996268 |
| Variance | 0.08900440779 |
| Value | Count | Frequency (%) | |
| 0 | 4302 | 48.1% | |
| 0.083333 | 1104 | 12.3% | |
| 0.166667 | 592 | 6.6% | |
| 1 | 481 | 5.4% | |
| 0.25 | 418 | 4.7% | |
| 0.333333 | 355 | 4.0% | |
| 0.416667 | 244 | 2.7% | |
| 0.5 | 235 | 2.6% | |
| 0.583333 | 197 | 2.2% | |
| 0.666667 | 167 | 1.9% | |
| Other values (37) | 855 | 9.6% |
| Value | Count | Frequency (%) | |
| 0 | 4302 | 48.1% | |
| 0.083333 | 1104 | 12.3% | |
| 0.090909 | 56 | 0.6% | |
| 0.1 | 39 | 0.4% | |
| 0.111111 | 26 | 0.3% |
| Value | Count | Frequency (%) | |
| 1 | 481 | 5.4% | |
| 0.916667 | 151 | 1.7% | |
| 0.909091 | 4 | < 0.1% | |
| 0.9 | 1 | < 0.1% | |
| 0.888889 | 2 | < 0.1% |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.3644373415642458 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.0 |
| Zeros | 3915 |
| Zeros (%) | 43.7% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.166667 |
| Q3 | 0.75 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.75 |
Descriptive statistics
| Standard deviation | 0.3974477797 |
|---|---|
| Coefficient of variation (CV) | 1.090579187 |
| Kurtosis | -1.398632185 |
| Mean | 0.3644373416 |
| Median Absolute Deviation (MAD) | 0.166667 |
| Skewness | 0.509201165 |
| Sum | 3261.714207 |
| Variance | 0.1579647376 |
| Value | Count | Frequency (%) | |
| 0 | 3915 | 43.7% | |
| 1 | 1331 | 14.9% | |
| 0.416667 | 388 | 4.3% | |
| 0.916667 | 345 | 3.9% | |
| 0.833333 | 311 | 3.5% | |
| 0.5 | 310 | 3.5% | |
| 0.166667 | 305 | 3.4% | |
| 0.666667 | 292 | 3.3% | |
| 0.75 | 291 | 3.3% | |
| 0.083333 | 275 | 3.1% | |
| Other values (37) | 1187 | 13.3% |
| Value | Count | Frequency (%) | |
| 0 | 3915 | 43.7% | |
| 0.083333 | 275 | 3.1% | |
| 0.090909 | 12 | 0.1% | |
| 0.1 | 6 | 0.1% | |
| 0.111111 | 9 | 0.1% |
| Value | Count | Frequency (%) | |
| 1 | 1331 | 14.9% | |
| 0.916667 | 345 | 3.9% | |
| 0.909091 | 25 | 0.3% | |
| 0.9 | 19 | 0.2% | |
| 0.888889 | 28 | 0.3% |
| Distinct count | 54 |
|---|---|
| Unique (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.13514420033519556 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.5 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.222222 |
| 95-th percentile | 0.583333 |
| Maximum | 1.5 |
| Range | 1.5 |
| Interquartile range (IQR) | 0.222222 |
Descriptive statistics
| Standard deviation | 0.2001213881 |
|---|---|
| Coefficient of variation (CV) | 1.480798937 |
| Kurtosis | 3.334734328 |
| Mean | 0.1351442003 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.828686266 |
| Sum | 1209.540593 |
| Variance | 0.04004856999 |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 0.083333 | 1021 | 11.4% | |
| 0.166667 | 759 | 8.5% | |
| 0.25 | 578 | 6.5% | |
| 0.333333 | 439 | 4.9% | |
| 0.416667 | 273 | 3.1% | |
| 0.5 | 215 | 2.4% | |
| 0.583333 | 142 | 1.6% | |
| 0.666667 | 125 | 1.4% | |
| 0.090909 | 70 | 0.8% | |
| Other values (44) | 700 | 7.8% |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 0.083333 | 1021 | 11.4% | |
| 0.090909 | 70 | 0.8% | |
| 0.1 | 39 | 0.4% | |
| 0.111111 | 29 | 0.3% |
| Value | Count | Frequency (%) | |
| 1.5 | 1 | < 0.1% | |
| 1.25 | 1 | < 0.1% | |
| 1.166667 | 2 | < 0.1% | |
| 1.142857 | 1 | < 0.1% | |
| 1.125 | 1 | < 0.1% |
| Distinct count | 65 |
|---|---|
| Unique (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.2488268156424582 |
|---|---|
| Minimum | 0 |
| Maximum | 123 |
| Zeros | 4628 |
| Zeros (%) | 51.7% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 4 |
| 95-th percentile | 15 |
| Maximum | 123 |
| Range | 123 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 6.824646744 |
|---|---|
| Coefficient of variation (CV) | 2.100649598 |
| Kurtosis | 61.64686248 |
| Mean | 3.248826816 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.721298203 |
| Sum | 29077 |
| Variance | 46.57580318 |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 1 | 887 | 9.9% | |
| 2 | 620 | 6.9% | |
| 3 | 436 | 4.9% | |
| 4 | 384 | 4.3% | |
| 5 | 308 | 3.4% | |
| 6 | 246 | 2.7% | |
| 7 | 205 | 2.3% | |
| 8 | 171 | 1.9% | |
| 10 | 150 | 1.7% | |
| Other values (55) | 915 | 10.2% |
| Value | Count | Frequency (%) | |
| 0 | 4628 | 51.7% | |
| 1 | 887 | 9.9% | |
| 2 | 620 | 6.9% | |
| 3 | 436 | 4.9% | |
| 4 | 384 | 4.3% |
| Value | Count | Frequency (%) | |
| 123 | 3 | < 0.1% | |
| 110 | 1 | < 0.1% | |
| 107 | 1 | < 0.1% | |
| 93 | 1 | < 0.1% | |
| 80 | 1 | < 0.1% |
| Distinct count | 173 |
|---|---|
| Unique (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 14.709832402234637 |
|---|---|
| Minimum | 0 |
| Maximum | 358 |
| Zeros | 2044 |
| Zeros (%) | 22.8% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 7 |
| Q3 | 17 |
| 95-th percentile | 57 |
| Maximum | 358 |
| Range | 358 |
| Interquartile range (IQR) | 16 |
Descriptive statistics
| Standard deviation | 24.85764911 |
|---|---|
| Coefficient of variation (CV) | 1.689866236 |
| Kurtosis | 34.79310026 |
| Mean | 14.7098324 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 4.630655266 |
| Sum | 131653 |
| Variance | 617.9027193 |
| Value | Count | Frequency (%) | |
| 0 | 2044 | 22.8% | |
| 1 | 667 | 7.5% | |
| 12 | 570 | 6.4% | |
| 2 | 379 | 4.2% | |
| 6 | 352 | 3.9% | |
| 3 | 314 | 3.5% | |
| 4 | 285 | 3.2% | |
| 7 | 275 | 3.1% | |
| 8 | 267 | 3.0% | |
| 5 | 267 | 3.0% | |
| Other values (163) | 3530 | 39.4% |
| Value | Count | Frequency (%) | |
| 0 | 2044 | 22.8% | |
| 1 | 667 | 7.5% | |
| 2 | 379 | 4.2% | |
| 3 | 314 | 3.5% | |
| 4 | 285 | 3.2% |
| Value | Count | Frequency (%) | |
| 358 | 1 | < 0.1% | |
| 347 | 1 | < 0.1% | |
| 344 | 1 | < 0.1% | |
| 309 | 1 | < 0.1% | |
| 308 | 1 | < 0.1% |
CREDIT_LIMIT
Real number (ℝ≥0)
| Distinct count | 205 |
|---|---|
| Unique (%) | 2.3% |
| Missing | 1 |
| Missing (%) | < 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4494.449450364621 |
|---|---|
| Minimum | 50.0 |
| Maximum | 30000.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 50 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1600 |
| median | 3000 |
| Q3 | 6500 |
| 95-th percentile | 12000 |
| Maximum | 30000 |
| Range | 29950 |
| Interquartile range (IQR) | 4900 |
Descriptive statistics
| Standard deviation | 3638.815725 |
|---|---|
| Coefficient of variation (CV) | 0.8096243524 |
| Kurtosis | 2.836655932 |
| Mean | 4494.44945 |
| Median Absolute Deviation (MAD) | 1800 |
| Skewness | 1.522464005 |
| Sum | 40220828.13 |
| Variance | 13240979.88 |
| Value | Count | Frequency (%) | |
| 3000 | 784 | 8.8% | |
| 1500 | 722 | 8.1% | |
| 1200 | 621 | 6.9% | |
| 1000 | 614 | 6.9% | |
| 2500 | 612 | 6.8% | |
| 4000 | 506 | 5.7% | |
| 6000 | 463 | 5.2% | |
| 5000 | 389 | 4.3% | |
| 2000 | 371 | 4.1% | |
| 7500 | 277 | 3.1% | |
| Other values (195) | 3590 | 40.1% |
| Value | Count | Frequency (%) | |
| 50 | 1 | < 0.1% | |
| 150 | 5 | 0.1% | |
| 200 | 3 | < 0.1% | |
| 300 | 14 | 0.2% | |
| 400 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 30000 | 2 | < 0.1% | |
| 28000 | 1 | < 0.1% | |
| 25000 | 1 | < 0.1% | |
| 23000 | 2 | < 0.1% | |
| 22500 | 1 | < 0.1% |
| Distinct count | 8711 |
|---|---|
| Unique (%) | 97.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1733.1438520248043 |
|---|---|
| Minimum | 0.0 |
| Maximum | 50721.483360000006 |
| Zeros | 240 |
| Zeros (%) | 2.7% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 89.98892395 |
| Q1 | 383.276166 |
| median | 856.901546 |
| Q3 | 1901.134317 |
| 95-th percentile | 6082.090595 |
| Maximum | 50721.48336 |
| Range | 50721.48336 |
| Interquartile range (IQR) | 1517.858151 |
Descriptive statistics
| Standard deviation | 2895.063757 |
|---|---|
| Coefficient of variation (CV) | 1.670411693 |
| Kurtosis | 54.77073581 |
| Mean | 1733.143852 |
| Median Absolute Deviation (MAD) | 581.3514605 |
| Skewness | 5.907619794 |
| Sum | 15511637.48 |
| Variance | 8381394.157 |
| Value | Count | Frequency (%) | |
| 0 | 240 | 2.7% | |
| 806.587482 | 1 | < 0.1% | |
| 836.812414 | 1 | < 0.1% | |
| 139.607827 | 1 | < 0.1% | |
| 107.242408 | 1 | < 0.1% | |
| 433.860714 | 1 | < 0.1% | |
| 402.20014 | 1 | < 0.1% | |
| 308.886492 | 1 | < 0.1% | |
| 238.695115 | 1 | < 0.1% | |
| 197.86349 | 1 | < 0.1% | |
| Other values (8701) | 8701 | 97.2% |
| Value | Count | Frequency (%) | |
| 0 | 240 | 2.7% | |
| 0.049513 | 1 | < 0.1% | |
| 0.056466 | 1 | < 0.1% | |
| 2.389583 | 1 | < 0.1% | |
| 3.500505 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 50721.48336 | 1 | < 0.1% | |
| 46930.59824 | 1 | < 0.1% | |
| 40627.59524 | 1 | < 0.1% | |
| 39461.9658 | 1 | < 0.1% | |
| 39048.59762 | 1 | < 0.1% |
| Distinct count | 8636 |
|---|---|
| Unique (%) | > 99.9% |
| Missing | 313 |
| Missing (%) | 3.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 864.2065423050827 |
|---|---|
| Minimum | 0.019163 |
| Maximum | 76406.20752000001 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0.019163 |
|---|---|
| 5-th percentile | 73.2820058 |
| Q1 | 169.123707 |
| median | 312.343947 |
| Q3 | 825.485459 |
| 95-th percentile | 2766.56331 |
| Maximum | 76406.20752 |
| Range | 76406.18836 |
| Interquartile range (IQR) | 656.361752 |
Descriptive statistics
| Standard deviation | 2372.446607 |
|---|---|
| Coefficient of variation (CV) | 2.745231019 |
| Kurtosis | 283.9899859 |
| Mean | 864.2065423 |
| Median Absolute Deviation (MAD) | 190.374096 |
| Skewness | 13.62279699 |
| Sum | 7464151.906 |
| Variance | 5628502.901 |
| Value | Count | Frequency (%) | |
| 299.351881 | 2 | < 0.1% | |
| 284.70693 | 1 | < 0.1% | |
| 144.641814 | 1 | < 0.1% | |
| 1927.887547 | 1 | < 0.1% | |
| 6825.44203 | 1 | < 0.1% | |
| 342.412476 | 1 | < 0.1% | |
| 5583.630482 | 1 | < 0.1% | |
| 125.3494 | 1 | < 0.1% | |
| 3.19794 | 1 | < 0.1% | |
| 140.596138 | 1 | < 0.1% | |
| Other values (8626) | 8626 | 96.4% | |
| (Missing) | 313 | 3.5% |
| Value | Count | Frequency (%) | |
| 0.019163 | 1 | < 0.1% | |
| 0.037744 | 1 | < 0.1% | |
| 0.05588 | 1 | < 0.1% | |
| 0.059481 | 1 | < 0.1% | |
| 0.117036 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 76406.20752 | 1 | < 0.1% | |
| 61031.6186 | 1 | < 0.1% | |
| 56370.04117 | 1 | < 0.1% | |
| 50260.75947 | 1 | < 0.1% | |
| 43132.72823 | 1 | < 0.1% |
| Distinct count | 47 |
|---|---|
| Unique (%) | 0.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.15371464849162012 |
|---|---|
| Minimum | 0.0 |
| Maximum | 1.0 |
| Zeros | 5903 |
| Zeros (%) | 66.0% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0.142857 |
| 95-th percentile | 1 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.142857 |
Descriptive statistics
| Standard deviation | 0.2924991962 |
|---|---|
| Coefficient of variation (CV) | 1.902871321 |
| Kurtosis | 2.432395301 |
| Mean | 0.1537146485 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.942819941 |
| Sum | 1375.746104 |
| Variance | 0.0855557798 |
| Value | Count | Frequency (%) | |
| 0 | 5903 | 66.0% | |
| 1 | 488 | 5.5% | |
| 0.083333 | 426 | 4.8% | |
| 0.166667 | 166 | 1.9% | |
| 0.25 | 156 | 1.7% | |
| 0.5 | 156 | 1.7% | |
| 0.090909 | 153 | 1.7% | |
| 0.333333 | 134 | 1.5% | |
| 0.1 | 94 | 1.1% | |
| 0.2 | 83 | 0.9% | |
| Other values (37) | 1191 | 13.3% |
| Value | Count | Frequency (%) | |
| 0 | 5903 | 66.0% | |
| 0.083333 | 426 | 4.8% | |
| 0.090909 | 153 | 1.7% | |
| 0.1 | 94 | 1.1% | |
| 0.111111 | 61 | 0.7% |
| Value | Count | Frequency (%) | |
| 1 | 488 | 5.5% | |
| 0.916667 | 77 | 0.9% | |
| 0.909091 | 19 | 0.2% | |
| 0.9 | 16 | 0.2% | |
| 0.888889 | 12 | 0.1% |
TENURE
Real number (ℝ≥0)
| Distinct count | 7 |
|---|---|
| Unique (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.51731843575419 |
|---|---|
| Minimum | 6 |
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 69.9 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 12 |
| median | 12 |
| Q3 | 12 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 6 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.338330769 |
|---|---|
| Coefficient of variation (CV) | 0.1162015947 |
| Kurtosis | 7.694823186 |
| Mean | 11.51731844 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | -2.943017288 |
| Sum | 103080 |
| Variance | 1.791129248 |
| Value | Count | Frequency (%) | |
| 12 | 7584 | 84.7% | |
| 11 | 365 | 4.1% | |
| 10 | 236 | 2.6% | |
| 6 | 204 | 2.3% | |
| 8 | 196 | 2.2% | |
| 7 | 190 | 2.1% | |
| 9 | 175 | 2.0% |
| Value | Count | Frequency (%) | |
| 6 | 204 | 2.3% | |
| 7 | 190 | 2.1% | |
| 8 | 196 | 2.2% | |
| 9 | 175 | 2.0% | |
| 10 | 236 | 2.6% |
| Value | Count | Frequency (%) | |
| 12 | 7584 | 84.7% | |
| 11 | 365 | 4.1% | |
| 10 | 236 | 2.6% | |
| 9 | 175 | 2.0% | |
| 8 | 196 | 2.2% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| CUST_ID | BALANCE | BALANCE_FREQUENCY | PURCHASES | ONEOFF_PURCHASES | INSTALLMENTS_PURCHASES | CASH_ADVANCE | PURCHASES_FREQUENCY | ONEOFF_PURCHASES_FREQUENCY | PURCHASES_INSTALLMENTS_FREQUENCY | CASH_ADVANCE_FREQUENCY | CASH_ADVANCE_TRX | PURCHASES_TRX | CREDIT_LIMIT | PAYMENTS | MINIMUM_PAYMENTS | PRC_FULL_PAYMENT | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | C10001 | 40.900749 | 0.818182 | 95.40 | 0.00 | 95.40 | 0.000000 | 0.166667 | 0.000000 | 0.083333 | 0.000000 | 0 | 2 | 1000.0 | 201.802084 | 139.509787 | 0.000000 | 12 |
| 1 | C10002 | 3202.467416 | 0.909091 | 0.00 | 0.00 | 0.00 | 6442.945483 | 0.000000 | 0.000000 | 0.000000 | 0.250000 | 4 | 0 | 7000.0 | 4103.032597 | 1072.340217 | 0.222222 | 12 |
| 2 | C10003 | 2495.148862 | 1.000000 | 773.17 | 773.17 | 0.00 | 0.000000 | 1.000000 | 1.000000 | 0.000000 | 0.000000 | 0 | 12 | 7500.0 | 622.066742 | 627.284787 | 0.000000 | 12 |
| 3 | C10004 | 1666.670542 | 0.636364 | 1499.00 | 1499.00 | 0.00 | 205.788017 | 0.083333 | 0.083333 | 0.000000 | 0.083333 | 1 | 1 | 7500.0 | 0.000000 | NaN | 0.000000 | 12 |
| 4 | C10005 | 817.714335 | 1.000000 | 16.00 | 16.00 | 0.00 | 0.000000 | 0.083333 | 0.083333 | 0.000000 | 0.000000 | 0 | 1 | 1200.0 | 678.334763 | 244.791237 | 0.000000 | 12 |
| 5 | C10006 | 1809.828751 | 1.000000 | 1333.28 | 0.00 | 1333.28 | 0.000000 | 0.666667 | 0.000000 | 0.583333 | 0.000000 | 0 | 8 | 1800.0 | 1400.057770 | 2407.246035 | 0.000000 | 12 |
| 6 | C10007 | 627.260806 | 1.000000 | 7091.01 | 6402.63 | 688.38 | 0.000000 | 1.000000 | 1.000000 | 1.000000 | 0.000000 | 0 | 64 | 13500.0 | 6354.314328 | 198.065894 | 1.000000 | 12 |
| 7 | C10008 | 1823.652743 | 1.000000 | 436.20 | 0.00 | 436.20 | 0.000000 | 1.000000 | 0.000000 | 1.000000 | 0.000000 | 0 | 12 | 2300.0 | 679.065082 | 532.033990 | 0.000000 | 12 |
| 8 | C10009 | 1014.926473 | 1.000000 | 861.49 | 661.49 | 200.00 | 0.000000 | 0.333333 | 0.083333 | 0.250000 | 0.000000 | 0 | 5 | 7000.0 | 688.278568 | 311.963409 | 0.000000 | 12 |
| 9 | C10010 | 152.225975 | 0.545455 | 1281.60 | 1281.60 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 3 | 11000.0 | 1164.770591 | 100.302262 | 0.000000 | 12 |
Last rows
| CUST_ID | BALANCE | BALANCE_FREQUENCY | PURCHASES | ONEOFF_PURCHASES | INSTALLMENTS_PURCHASES | CASH_ADVANCE | PURCHASES_FREQUENCY | ONEOFF_PURCHASES_FREQUENCY | PURCHASES_INSTALLMENTS_FREQUENCY | CASH_ADVANCE_FREQUENCY | CASH_ADVANCE_TRX | PURCHASES_TRX | CREDIT_LIMIT | PAYMENTS | MINIMUM_PAYMENTS | PRC_FULL_PAYMENT | TENURE | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8940 | C19181 | 130.838554 | 1.000000 | 591.24 | 0.00 | 591.24 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 475.523262 | 82.771320 | 1.00 | 6 |
| 8941 | C19182 | 5967.475270 | 0.833333 | 214.55 | 0.00 | 214.55 | 8555.409326 | 0.833333 | 0.000000 | 0.666667 | 0.666667 | 13 | 5 | 9000.0 | 966.202912 | 861.949906 | 0.00 | 6 |
| 8942 | C19183 | 40.829749 | 1.000000 | 113.28 | 0.00 | 113.28 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 94.488828 | 86.283101 | 0.25 | 6 |
| 8943 | C19184 | 5.871712 | 0.500000 | 20.90 | 20.90 | 0.00 | 0.000000 | 0.166667 | 0.166667 | 0.000000 | 0.000000 | 0 | 1 | 500.0 | 58.644883 | 43.473717 | 0.00 | 6 |
| 8944 | C19185 | 193.571722 | 0.833333 | 1012.73 | 1012.73 | 0.00 | 0.000000 | 0.333333 | 0.333333 | 0.000000 | 0.000000 | 0 | 2 | 4000.0 | 0.000000 | NaN | 0.00 | 6 |
| 8945 | C19186 | 28.493517 | 1.000000 | 291.12 | 0.00 | 291.12 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 325.594462 | 48.886365 | 0.50 | 6 |
| 8946 | C19187 | 19.183215 | 1.000000 | 300.00 | 0.00 | 300.00 | 0.000000 | 1.000000 | 0.000000 | 0.833333 | 0.000000 | 0 | 6 | 1000.0 | 275.861322 | NaN | 0.00 | 6 |
| 8947 | C19188 | 23.398673 | 0.833333 | 144.40 | 0.00 | 144.40 | 0.000000 | 0.833333 | 0.000000 | 0.666667 | 0.000000 | 0 | 5 | 1000.0 | 81.270775 | 82.418369 | 0.25 | 6 |
| 8948 | C19189 | 13.457564 | 0.833333 | 0.00 | 0.00 | 0.00 | 36.558778 | 0.000000 | 0.000000 | 0.000000 | 0.166667 | 2 | 0 | 500.0 | 52.549959 | 55.755628 | 0.25 | 6 |
| 8949 | C19190 | 372.708075 | 0.666667 | 1093.25 | 1093.25 | 0.00 | 127.040008 | 0.666667 | 0.666667 | 0.000000 | 0.333333 | 2 | 23 | 1200.0 | 63.165404 | 88.288956 | 0.00 | 6 |